<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateItemTasksTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('items_tasks',function(Blueprint $table){

            $table->increments('id')->comment('ID');
            $table->integer('item_id')->comment('项目ID');
            $table->integer('template_id')->comment('模板ID');
            $table->string('task_name')->comment('任务名称');
            $table->integer('task_level')->comment('任务等级');
            $table->integer('task_id')->comment('模板任务ID');
            $table->integer('stage_id')->comment('阶段ID');
            $table->integer('task_status')->comment('任务状态');
            $table->integer('member_id_task')->comment('任务人ID');
            $table->integer('member_id_check')->comment('审核人ID');
            $table->string('task_deadline')->comment('任务截止时间');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
